{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calcul handicap 2020","Slopes","Explications","A propos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calcul handicap 2020","index":0,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Date","Lieu","Type","Nb","SGD",{"$f":"ROUND(M2,1)","v":0}]
[null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,"Lieu"]
[null,null,null,null,null,null,null,"Officiel ou amical"]
[null,null,null,null,null,null,null,"Nb trous"]
[null,null,null,null,null,null,null,"Hcp départ"]
[null,null,null,null,null,null,null,"Stableford"]
[null,null,null,null,null,null,null,"Slope en manuel"]
[null,null,null,null,null,null,null,"Slope",{"$f":"IF(I10=\"Hommes jaunes\",VLOOKUP(I3,Slopes!A2:D80,3,0),IF(I10=\"Dames Rouges\",VLOOKUP(I3,Slopes!A2:D80,4,0)))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"IF(I10=\"Hommes jaunes\",3,IF(I10=\"Dames rouges\",4,0))","v":3}]
[null,null,null,null,null,null,null,"Tee départ","Hommes jaunes"]
[]
[null,null,null,null,null,null,null,"SGD",{"$f":"IF(ISBLANK(I8),IF(I5=18,ROUND(I6+((36-I7)*(113/I9)),0),ROUND(I6+((36-I7)*(113/I9)),0)-18),IF(I5=18,ROUND(I6+((36-I7)*(113/I8)),0),ROUND(I6+((36-I7)*(113/I8)),0)-18))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,"Utiliser les drapeaux pour insérer une nouvelle ligne"]
[null,null,null,null,null,null,null,"Utiliser la calculatrice pour recalculer le nouvel handicap"]

{"sheet":"Slopes","index":1,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Terrain",null,"Slope jaunes hommes","Slope rouges dames"]
["Rougemont","Jaunes",127,129]
["Naxhelet","Jaunes",118,116]
[]
["Anderlecht","Blancs",116]
["Avernas","Jaunes",109,110]
["Bawette","Jaunes",123,116]
["Bercuit","Jaunes",125,124]
["Bernalmont","Jaunes",116,115]
["La Bruyère","Jaunes",127,118]
["Duisburg","Jaunes",103]
["Durbuy","Jaunes",121,118]
["L'Empereur","Jaunes",129]
["Enghien","Jaunes",129]
["Falnuée","Jaunes",124,123]
["Flanders Nippon Hasselt","Jaunes",125]
["Florennes","Jaunes",115]
["Gomzé","Jaunes",127,127]
["Royal Hainaut","Jaunes",131,null,"Quesnoy - Etangs"]
["Royal Hainaut","Jaunes",131,null,"Bruyère - Etangs"]
["Royal Hainaut","Jaunes",124,null,"Bruyère - Quesnoy"]
["Haras","Jaunes",116,116]
["Hulencourt","Jaunes",123]
["LLN","Jaunes",124,120]
["Méan","Jaunes",124,123]
["Millenium","Jaunes",118,114]
["Mont Garni","Jaunes",127,126]
["Pierpont","Jaunes",126,122]
["Ragnies","Jaunes",113,115]
["Rigenée","Jaunes",125,122]
["Sart Tilman","Jaunes",117]
["Spa","Jaunes",121,122]
["Tournette anglais","Jaunes",125,126]
["Tournette américain","Jaunes",126]
[]
[]
[]
["Amnéville-les-Thermes","Jaunes",135,133]
["Avignon (Garden golf)","Jaunes",122,121]
["Bellefontaine","Jaunes",125]
["Brigode","Jaunes",126]
["Chapelle-en-Vercors","Jaunes",113,106]
["Château d'Humières","Jaunes",121]
["La Commanderie","Jaunes",132,127]
["Corrençon-en-Vercors","Jaunes",119,121]
["Dunkerque","Jaunes",123,121]
["Etretat","Jaunes",132,131]
["Laguiole","Jaunes",133,131]
["Lancieux","Jaunes ",125,126]
["Lille-Métropole","Jaunes",125,122]
["Mâcon la Salle","Jaunes",123,120]
["Mérignies","Jaunes",132,128,"Val de Marque et Rupilly "]
["Mortemart","Jaunes",124,126]
["Pléneuf-Val-André","Jaunes",129,125]
["Poursaudes","Jaunes",131,127]
["Sables d'Or","Jaunes",126,126]
["Sorelle","Jaunes",124,120]
["Saint-Cast-le-Guildo","Jaunes",122,120]
["Vézac","Jaunes",122,113]

{"sheet":"Explications","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["En 2020, le handicap sera calculé selon les 8 meilleurs scores sur les 20 dernières parties, amicales ou officielles."]
[]
["Je présuppose que ce calcul sera effectué en se basant sur le SGD (standard gross differential)",null,null,null,null,null,null,null,null,"SGD = EGA Hcp + [ (36 – score Stb)x(113/Slope) ] "]
[]
["D’abord remplir le formulaire à droite."]
[]
["Certains terrains sont déjà répertoriés, et leur slope est adapté en conséquence (par défaut, le slope correspond au départ des jaunes)"]
[]
["Si le départ est autre que le jaune (et donc le slope), il faut remplir celui-ci manuellement (slope en manuel)"]
[]
[]
["Appuyer sur l’icône « drapeaux » en haut à gauche"]
["Pour connaître le handicap, appuyer sur la calculatrice en haut à gauche"]

{"sheet":"A propos","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Version 1.0"]
["2019-01-01"]
["Pierre Gillain"]